{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["LED Return on Investment Calcul","Lookup Values"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LED Return on Investment Calcul","index":0,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":false,"merged":[[69,3,69,4],[61,3,61,4],[63,3,63,4],[20,3,20,4],[24,3,24,4],[34,3,34,4],[37,3,37,4],[27,3,27,4],[30,3,30,4],[56,3,56,4],[11,3,11,4],[14,3,14,4],[67,3,67,4],[40,3,40,4],[43,3,43,4],[50,3,50,4],[53,3,53,4],[17,3,17,4],[46,3,46,4]]}
[]
["Exxon Lighting LED Savings Calculator"]
["Learn how much you can save by replacing with LED Lighting."]
["For a quick savings calculation, plug in your values in the sections below."]
["For more precise calculations, please contact Exxon Lighting Tech support at 800-769-3221."]
["Visit www.exxonlighting.com for information on our LED products."]
["Please enter your information"]
[null,null,null,"Ready for Calc2",{"$f":"IF(OR(D12=\"\",D15=\"\",D18=\"\",D21=\"\",D25=\"\",D28=\"\",D31=\"\",D35=\"\",D38=\"\",D41=\"\",D44=\"\",D47=\"\",D51=\"\",D54=\"\",D57=\"\"),0,1)","v":1}]
["Existing Bulb information",null,null,"Ready for Calc1",{"$f":"IF(OR(D12=\"\",D25=\"\",D28=\"\",D31=\"\",D35=\"\",D51=\"\"),0,1)","v":1}]
["Existing Bulb information"]
[]
["Existing Bulb Wattage (W)",null,null,400]
[]
[]
["Existing Bulb Unit Cost ($)",null,null,15]
[]
[]
["Existing Ballast Unit Cost ($)",null,null,60]
[]
[]
["Existing Bulb Life (Hrs)",null,null,15000]
[]
["Usage"]
[]
["Number of Bulbs in Use",null,null,20]
[]
[]
["Hours of Daily Use Per Bulb",null,null,10]
[]
[]
["Existing Bulb Use Per Year (# of Days)",null,null,200]
[]
["Energy / Labor Cost Information"]
[]
["Energy Cost ($/KwH)",null,null,0.1]
[]
[]
["Bulb Replacement Labor Rate ($/hr)",null,null,20]
[]
[]
["Time To Replace Bulb (Minutes)",null,null,60]
[]
[]
["Number of Workers to Replace Bulbs",null,null,2]
[]
[]
["Lift Device Cost ($)",null,null,200]
[]
["LED Bulb Information"]
[]
["LED Bulb Wattage (W)",null,null,100]
[]
[]
["LED Bulb Unit Cost ($)",null,null,150]
[]
[]
["LED Bulb Life (Hrs)",null,null,50000]
[]
[]
["YOUR LED ENERGY COST SAVINGS"]
[]
["Energy Savings Per Year ($)",null,null,{"$f":"IF(E9=0,\"\",(D12-D51)*D25*D28*D31/1000*D35)","v":1200}]
[]
["Energy Savings Over Life of LED bulbs ($/hr)",null,null,{"$f":"IF(E8=0,\"\",D62*(D57/(D28*D31)))","v":30000}]
[]
["Total Savings (Labor/Bulb costs/Energy)"]
[]
["Over the Life of the LED Bulbs ($)",null,null,{"$f":"IF(E8=0,\"\",((D57/D21)-1)*(D41/60)*D38*D44*D25+(((D15 + D18)*D25 + D47)*(D57/D21))-(D54*D25)+D64)","v":34533.333333333336}]
[]
["Payback of Investment in Months",null,null,{"$f":"IF(E8=0,\"\",(D54*D25)/ (D68/((D57/(D31*D28))*12)))","v":26.061776061776062}]
[]
[]
["© Exxon Lighting Corporation 2016"]

{"sheet":"Lookup Values","index":1,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Bulb Wattage","Unit Cost","Ballast Unit Cost","Bulb Life","Bulbs in Use","Hours of Use","Use Per Year","Cost","Labor Rate","Time to Replace","Number of Workers","Led Wattage","Led Unit Cost","Led Bulb Life","Lift Device Cost"]
[70,5,10,5000,10,4,100,7.0000000000000007E-2,10,15,1,20,100,20000,50]
[100,10,20,10000,20,8,200,0.08,15,30,2,30,200,25000,100]
[125,15,30,15000,30,12,365,0.09,20,45,3,40,300,30000,150]
[150,20,40,20000,40,16,null,0.1,25,60,4,50,400,40000,200]
[175,25,50,null,50,20,null,0.11,30,90,null,60,500,50000,300]
[250,30,60,null,60,24,null,0.12,40,120,null,75,600,null,400]
[400,35,75,null,75,null,null,0.13,50,null,null,95,null,null,500]
[1000,40,100,null,100,null,null,0.14000000000000001,null,null,null,100]
[1500,50,null,null,null,null,null,null,null,null,null,120]
[null,60,null,null,null,null,null,null,null,null,null,150]
[null,null,null,null,null,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,null,null,null,null,300]